<!DOCTYPE html>
<!-- saved from url=(0146)http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&btnG=%E0%B8%84%E0%B9%89%E0%B8%99%E0%B8%AB%E0%B8%B2&meta=&aq=f&oq= -->
<HTML><STYLE>#gview-cmenu {
  position: absolute;
  border: 1px solid #ccc;
  background: #fff;
  margin: 0;
  padding: 0;
  top: 0;
  left: 0;
  z-index: 10000;
  list-style-type: none;
  -webkit-box-shadow: 0 3px 5px rgba(0, 0, 0, .5);
}

#gview-cmenu:focus {
  outline: none;
}

.gview-cmenu-item {
  margin: 0;
  padding: 5px 7px;
  cursor: default;
  font-size: 13px;
  font-family: arial, san-serif;
  color: #000;
  -webkit-user-select: none;
}

.gview-cmenu-item:hover {
  background-color: #F0F7F9;
}

.gview-cmenu-item:first-child {
  border-bottom: 1px solid #ddd;
}

.gview-hidden {
  display: none;
}
</STYLE><HEAD><META http-equiv="Content-Type" content="text/html; charset=UTF-8"><TITLE>access mdb  last id select @@identity - ค้นหาด้วย Google</TITLE><SCRIPT>window.google={kEI:"t1KYS7w6gY6RBa6PjIwB",kEXPI:"17259,17311,18167,23279,23984,24029",kCSI:{e:"17259,17311,18167,23279,23984,24029",ei:"t1KYS7w6gY6RBa6PjIwB",expi:"17259,17311,18167,23279,23984,24029"},ml:function(){},kHL:"th",time:function(){return(new Date).getTime()},log:function(b,d,c){var a=new Image,e=google,g=e.lc,f=e.li;a.onerror=(a.onload=(a.onabort=function(){delete g[f]}));g[f]=a;c=c||"/gen_204?atyp=i&ct="+b+"&cad="+d+"&zx="+google.time();a.src=c;e.li=f+1},lc:[],li:0,Toolbelt:{}};
window.google.sn="web";window.google.timers={load:{t:{start:(new Date).getTime()}}};try{window.google.pt=window.chrome&&window.chrome.csi&&Math.floor(window.chrome.csi().pageT);
}catch(u){}window.google.jsrt_kill=1;
</SCRIPT><STYLE>body{background:#fff;color:#000;margin:3px 8px}#gbar{float:left;height:22px}.gbh,.gbd{border-top:1px solid #c9d7f1;font-size:1px}.gbh{height:0;position:absolute;top:24px;width:100%}#gbs,.gbm{background:#fff;left:0;position:absolute;text-align:left;visibility:hidden;z-index:1000}.gbm{border:1px solid;border-color:#c9d7f1 #36c #36c #a2bae7;z-index:1001}#guser{padding-bottom:7px !important;text-align:right}#gbar,#guser{font-size:13px;padding-top:1px !important}.gb1{margin-right:.5em}.gb1,.gb3{zoom:1}.gb2{display:block;padding:.2em .5em}.gb2,.gb3{text-decoration:none}a.gb1,a.gb2,a.gb3,a.gb4{color:#00c !important}a.gb2:hover{background:#36c;color:#fff !important}a.gb1,a.gb2,a.gb3,.link{color:#20c!important}.ts{border-collapse:collapse}.ts td{padding:0}.ti,.bl,form,#res h3{display:inline}.ti{display:inline-table}.fl:link,.gl,.gl a:link{color:#77c}a:link,.w,#prs a:visited,#prs a:active,.q:active,.q:visited{color:#20c}.mblink:visited,a:visited{color:#551a8b}a:active{color:red}.cur{color:#a90a08;font-weight:bold}.b{font-weight:bold}.j{width:42em;font-size:82%}.s{max-width:42em}.sl{font-size:82%}#gb{text-align:right;padding:1px 0 7px;margin:0}.hd{position:absolute;width:1px;height:1px;top:-1000em;overflow:hidden}.f,.m,.c h2,#mbEnd h2{color:#676767}.a,cite,.cite,.cite:link{color:green;font-style:normal}#mbEnd{float:right}h1,ol{margin:0;padding:0}li.g,body,html,.std,.c h2,#mbEnd h2,h1{font-size:small;font-family:arial,sans-serif}.c h2,#mbEnd h2,h1{font-weight:normal}#ssb,.clr{clear:both;margin:0 8px}#nav a,#nav a:visited,.blk a{color:#000}#nav a{display:block}#nav .b a,#nav .b a:visited{color:#20c}#nav .i{color:#a90a08;font-weight:bold}.csb,.ss,#logo span,#rptglbl{background:url(/images/nav_logo8.png) no-repeat;overflow:hidden}.csb,.ss{background-position:0 0;height:26px;display:block}.ss{background-position:0 -88px;position:absolute;left:0;top:0}.cps{height:18px;overflow:hidden;width:114px}.mbi{width:13px;height:13px;background-position:-91px -74px;position:relative;top:2px;margin-right:3px}#nav td{padding:0;text-align:center}#logo{display:block;overflow:hidden;position:relative;width:103px;height:37px;margin:11px 0 7px}#logo img{border:none;position:absolute;left:-0px;top:-26px}.ws,.wsa,.wxs,.wci,.wxi,.wpb{background:url(/images/nav_logo8.png) no-repeat;border:0;cursor:pointer;display:none;margin-right:3px;height:14px;vertical-align:bottom;width:14px}.ws,.wsa{display:inline;height:14px;margin-left:5px;vertical-align:0;width:14px}.ws{background-position:-151px -32px}.wsa{background-position:-151px -47px}.wxs{background-position:-134px -44px;cursor:default;display:inline;height:16px;margin-left:8px;width:16px}.wci,.wxi{display:inline}.wci{background-position:-119px -87px;height:14px;width:16px}.wpb{background-position:-91px -74px;display:inline;height:13px;vertical-align:-2px;width:13px}.wxi{background-position:-104px -57px;height:14px;width:14px}.wcd{margin-top:2px;max-width:42em}.link{color:#00c;text-decoration:underline;cursor:pointer}.link:active{color:red}#logo span,.ch{cursor:pointer}.lst{font-family:arial,sans-serif;font-size:17px;vertical-align:middle}.lsb{-webkit-appearance:button;padding:0 8px;border:1px solid #999;-webkit-border-radius:2px;background:-webkit-gradient(linear,left top,left bottom,from(#fff),to(#ddd));font-family:arial,sans-serif;font-size:15px;height:1.85em;vertical-align:middle}.lsb:active{background:-webkit-gradient(linear,left top,left bottom,from(#ccc),to(#ddd))}h3,.med{font-size:medium;font-weight:normal;padding:0;margin:0}.e{margin:.75em 0}.bc a{color:green;text-decoration:none}.bc a:hover{text-decoration:underline}.slk td{padding-left:40px;padding-top:5px;vertical-align:top}.slk div{padding-left:10px;text-indent:-10px}.fc{margin-top:.5em;padding-left:3em}#mbEnd cite{display:block;text-align:left}#mbEnd p{margin:-.5em 0 0 .5em;text-align:center}#bsf,#ssb,.blk{border-top:1px solid #6b90da;background:#f0f7f9}#bsf{border-bottom:1px solid #6b90da}#flp{margin:7px 0}#ssb div{float:left;padding:4px 0 0;padding-left:7px;padding-right:.5em}#prs a,#prs b{margin-right:.6em}#ssb p{text-align:right;white-space:nowrap;margin:.1em 0;padding:.2em}#ssb{margin:0 8px 11px;padding:.1em}#cnt{max-width:80em;clear:both}#mbEnd{background:#fff;padding:0;border-left:11px solid #fff;border-spacing:0;white-space:nowrap}#res{padding-right:1em;margin:0 16px}.c{background:#fff8dd;margin:0 8px}.c li{padding:0 3px 0 8px;margin:0}.c .tam,.c .tal{padding-top:12px}#mbEnd li{margin:1em 0;padding:0}.xsm{font-size:x-small}.sm{margin:0 0 0 40px;padding:0}ol li{list-style:none}.sm li{margin:0}.gl,#bsf a,.nobr{white-space:nowrap}#mbEnd .med{white-space:normal}.sl,.r{display:inline;font-weight:normal;margin:0}.r{font-size:medium}h4.r{font-size:small}.mr{margin-top:-.5em}h3.tbpr{margin-top:.3em;margin-bottom:1em}img.tbpr {border:0px;width:15px;height:15px;margin-right:3px}.ri_cb{left:0;margin:6px;position:absolute;top:0;z-index:1}.ri_sp{display:-moz-inline-box;display:inline-block;text-align:center;vertical-align:top;margin-bottom:6px}.ri_sp img{vertical-align:bottom}em,.rbt b,.c b,#mbEnd b{color:#c03;font-style:normal;font-weight:normal}a em,a b{text-decoration:underline}.g{margin:1em 0}.mbl{margin:1em 0 0}.tbi div, #tbp{background:url(/images/nav_logo8.png) no-repeat;overflow:hidden;width:13px;height:13px;}#ssb #tbp{background-position:-91px -74px;padding:0;margin-top:1px;margin-left:0.75em;}.tbpo,.tbpc{margin-left:3px;margin-right:1em;text-decoration:underline;white-space:nowrap;}.tbpc,.tbo .tbpo {display:inline}.tbo .tbpc,.tbpo{display:none}#prs *{float:left}#prs a, #prs b{position:relative;bottom:.05em;margin-right:.3em}.std dfn{padding-left:.2em;padding-right:.5em}dfn{font-style:normal;font-weight:bold;padding-left:1px;padding-left:2px;position:relative;top:-.12em}#tbd{display:none;margin-left:-11.6em;z-index:1}.tbo #tads,.tbo #pp,.tbo #tadsb{margin-left:15em}.tbo #res{margin-left:13.05em;}.tbo #tbd{width:11.6em;padding:0;left:11px;background:#fff;border-right:1px solid #c9d7f1;position:absolute;display:block;margin-left:0}.tbo #mbEnd{width:26%}</STYLE><SCRIPT>google.y={};google.x=function(e,g){google.y[e.id]=[e,g];return false};if(!window.google)window.google={};window.google.crm={};window.google.cri=0;window.clk=function(d,e,f,j,k,l,m){if(document.images){var a=encodeURIComponent||escape,b=new Image,g=window.google.cri++;window.google.crm[g]=b;b.onerror=(b.onload=(b.onabort=function(){delete window.google.crm[g]}));b.src=["/url?sa=T","\x26source\x3dweb",e?"&oi="+a(e):"",f?"&cad="+a(f):"","&ct=",a(j||"res"),"&cd=",a(k),"&ved=",a(m),d?"&url="+a(d.replace(/#.*/,"")).replace(/\+/g,"%2B"):"","&ei=","t1KYS7w6gY6RBa6PjIwB",l].join("")}
return true};
window.gbar={qs:function(){},tg:function(e){var o={id:'gbar'};for(i in e)o[i]=e[i];google.x(o,function(){gbar.tg(o)})}};</SCRIPT><STYLE type="text/css">.gac_m{cursor:default;border:1px solid #000;z-index:99;background:#fff;position:absolute;margin:0;font-size:17px}.gac_m td{line-height:22px}.gac_b{background:#36c;color:#fff}.gac_c{padding-left:3px;white-space:nowrap;overflow:hidden;text-align:left;}.gac_d{padding:0 3px;white-space:nowrap;overflow:hidden;text-align:right;color:green;font-size:0.77em}.gac_b td{color:#fff}.gac_e{padding:0 3px 2px;text-decoration:underline;text-align:right;color:#00c;font-size:0.77em;line-height:0.88em}</STYLE></HEAD><BODY id="gsr" topmargin="3" marginheight="3"><TEXTAREA id="csi" style="display:none"></TEXTAREA><DIV id="gbar"><NOBR><B class="gb1">เว็บ</B> <A href="http://images.google.co.th/images?hl=th&q=access+mdb++last+id+select+%40%40identity&oq=&um=1&ie=UTF-8&sa=N&tab=wi" onclick="gbar.qs(this)" class="gb1">รูปภาพ</A> <A href="http://maps.google.co.th/maps?hl=th&q=access+mdb++last+id+select+%40%40identity&oq=&um=1&ie=UTF-8&sa=N&tab=wl" onclick="gbar.qs(this)" class="gb1">แผนที่</A> <A href="http://translate.google.co.th/translate_t?hl=th&q=access+mdb++last+id+select+%40%40identity&oq=&um=1&ie=UTF-8&sa=N&tab=wT" onclick="gbar.qs(this)" class="gb1">แปลภาษา</A> <A href="http://guru.google.co.th/guru/search?hl=th&q=access+mdb++last+id+select+%40%40identity&oq=&um=1&ie=UTF-8&sa=N&tab=w2" onclick="gbar.qs(this)" class="gb1">กูรู</A> <A href="http://blogsearch.google.co.th/blogsearch?hl=th&q=access+mdb++last+id+select+%40%40identity&oq=&um=1&ie=UTF-8&sa=N&tab=wb" onclick="gbar.qs(this)" class="gb1">บล็อก</A> <A href="http://mail.google.com/mail/?hl=th&tab=wm" class="gb1">Gmail</A> <A href="http://www.google.co.th/intl/th/options/" onclick="this.blur();gbar.tg(event);return !1" aria-haspopup="true" class="gb3"><U>เพิ่มเติม</U> <SMALL>▼</SMALL></A><DIV class="gbm" id="gbi"><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&oq=&cat=gwd/Top&um=1&ie=UTF-8&sa=N&tab=wd" onclick="gbar.qs(this)" class="gb2">ไดเรกทอรี</A> <A href="http://www.google.com/calendar/render?hl=th&tab=wc" class="gb2">ปฏิทิน</A> <A href="http://picasaweb.google.co.th/lh/view?hl=th&q=access+mdb++last+id+select+%40%40identity&oq=&um=1&ie=UTF-8&sa=N&tab=wq" onclick="gbar.qs(this)" class="gb2">ภาพถ่าย</A> <A href="http://docs.google.com/?hl=th&tab=wo" class="gb2">เอกสาร</A> <A href="http://sites.google.com/?hl=th&tab=w3" class="gb2">ไซต์</A> <A href="http://groups.google.co.th/groups?hl=th&q=access+mdb++last+id+select+%40%40identity&oq=&um=1&ie=UTF-8&sa=N&tab=wg" onclick="gbar.qs(this)" class="gb2">Groups</A> </DIV></NOBR></DIV><DIV id="guser" width="100%"><NOBR><B class="gb4">dorakengi@gmail.com</B> | <A href="http://www.google.co.th/history/?hl=th" class="gb4">Web History</A> | <A href="http://www.google.co.th/preferences?hl=th" onclick="this.blur();gbar.tg(event);return !1" aria-haspopup="true" aria-owns="gbg" class="gb3"><U>การตั้งค่า</U> <SMALL>▼</SMALL></A> | <A href="http://www.google.co.th/accounts/ClearSID?continue=http%3A%2F%2Fwww.google.com%2Faccounts%2FLogout%3Fcontinue%3Dhttp%3A%2F%2Fwww.google.co.th%2Fsearch%3Fhl%3Dth%26q%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26btnG%3D%25E0%25B8%2584%25E0%25B9%2589%25E0%25B8%2599%25E0%25B8%25AB%25E0%25B8%25B2%26aq%3Df%26oq%3D" class="gb4">ออกจากระบบ</A><DIV class="gbm" id="gbg"><A href="http://www.google.co.th/preferences?hl=th" class="gb2">การตั้งค่าการค้นหา</A> <A href="https://www.google.com/accounts/ManageAccount?hl=th" class="gb2">การตั้งค่าบัญชี Google</A> </DIV></NOBR></DIV><DIV class="gbh" style="left:0"></DIV><DIV class="gbh" style="right:0"></DIV><DIV id="cnt"><FORM id="tsf" name="gs" method="GET" action="http://www.google.co.th/search"><TABLE id="sft" class="ts" style="clear:both;margin:19px 16px 4px 15px"><TBODY><TR valign="top"><TD><H1><A id="logo" href="http://www.google.co.th/webhp?hl=th" title="ไปที่หน้าแรกของ Google">Google<IMG width="164" height="106" src="./access mdb last id select @@identity - ค้นหาด้วย Google_files/nav_logo8.png" alt=""></A></H1></TD><TD id="sff" style="padding:1px 3px 7px;padding-left:16px;width:100%"><TABLE class="ts" style="margin:12px 0 3px"><TBODY><TR><TD nowrap=""><INPUT type="hidden" name="hl" value="th"><INPUT autocomplete="off" class="lst" type="text" name="q" size="42" maxlength="2048" value="access mdb  last id select @@identity" title="ค้นหา"> <INPUT type="submit" name="btnG" class="lsb" style="margin:0 2px 0 5px" value="ค้นหา"></TD><TD style="padding:0 6px" class="nobr xsm"><A href="http://www.google.co.th/advanced_search?q=access+mdb++last+id+select+%40%40identity&hl=th">การค้นหาขั้นสูง</A><BR></TD></TR></TBODY></TABLE>  <DIV id="issferb">ค้นหา: <INPUT id="all" type="radio" name="meta" value="" checked=""><LABEL for="all"> เว็บ </LABEL> <INPUT id="lgr" type="radio" name="meta" value="lr=lang_th"><LABEL for="lgr"> หน้าที่เป็นภาษาไทย </LABEL> <INPUT id="cty" type="radio" name="meta" value="cr=countryTH"><LABEL for="cty"> เว็บจากประเทศไทย </LABEL> </DIV></TD></TR></TBODY></TABLE><INPUT type="hidden" name="aq" value="f"><INPUT type="hidden" name="oq" value="access mdb  last id "><TABLE cellpadding="0" cellspacing="0" class="gac_m" style="visibility: hidden; left: 144px; top: 86px; width: 379px; "></TABLE></FORM><DIV id="ssb"><DIV id="prs"><SPAN class="std"><B>เว็บ</B></SPAN><A href="http://www.google.co.th/search?q=access+mdb++last+id+select+%40%40identity&hl=th&sa=G&tbo=1" id="tbpi" class="q" onclick="return google.x(this,function(){return google.Toolbelt.toggle(this, event)})"><DIV id="tbp"></DIV><SPAN class="tbpo">ซ่อนตัวเลือก</SPAN><SPAN class="tbpc">แสดงตัวเลือก...</SPAN></A></DIV><P id="resultStats">&nbsp;ผลการค้นหา <B>1</B> - <B>10</B> จากประมาณ <B>9,000</B> รายการ สำหรับคำว่า <B>access mdb  last id select @@identity</B>  (<B>0.08</B> วินาที)&nbsp;</P></DIV><DIV id="tbd" class="med"><H2 class="hd"></H2></DIV><DIV id="res" class="med"><!--a--><H2 class="hd">ผลการค้นหา</H2><DIV><OL><!--m--><DIV></DIV><LI class="g w0"><H3 class="r"><A href="http://support.microsoft.com/kb/232144" class="l" onmousedown="return clk(this.href,&#39;&#39;,&#39;&#39;,&#39;res&#39;,&#39;1&#39;,&#39;&amp;sig2=d9zGozPaD8NZSZ_BQEb70w&#39;,&#39;0CAYQFjAA&#39;)">INFO: Jet OLE DB Provider Version 4.0 Supports <EM>SELECT</EM> @@<EM>Identity</EM></A></H3><SPAN style="display:inline-block"><BUTTON class="ws" title=""></BUTTON></SPAN><SPAN class="m">&nbsp;<SPAN dir="ltr">- 9:17</SPAN></SPAN><SPAN class="std nobr">&nbsp;- [ <A href="http://translate.google.co.th/translate?hl=th&sl=en&u=http://support.microsoft.com/kb/232144&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=translate&ct=result&resnum=1&ved=0CAkQ7gEwAA&prev=/search%3Fq%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26hl%3Dth%26sa%3DG" class="fl">แปลหน้านี้</A> ]</SPAN><DIV class="s">The Jet OLE DB version 4.0 provider supports the <EM>SELECT</EM> @@<EM>Identity</EM> query that allows you to <B>...</B> Article <EM>ID</EM>: 232144 - <EM>Last</EM> Review: December 3, 2003 - Revision: 3.1 <B>...</B> <EM>MDB</EM>" strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" &amp; _ "Data Source=" <B>...</B> You can create a new Jet 4.0 database using Microsoft <EM>Access</EM> 2000 or using <B>...</B><BR><CITE>support.microsoft.com/kb/232144 - </CITE><SPAN class="gl"><A href="http://www.google.co.th/search?hl=th&q=related:support.microsoft.com/kb/232144+access+mdb++last+id+select+%40%40identity&sa=X&ei=t1KYS7w6gY6RBa6PjIwB&ved=0CAcQHzAA">ใกล้เคียง</A></SPAN></DIV><!--n--><!--m--></LI><DIV></DIV><LI class="g w0" style="margin-left:3em"><H3 class="r"><A href="http://support.microsoft.com/kb/294842" class="l" onmousedown="return clk(this.href,&#39;&#39;,&#39;&#39;,&#39;res&#39;,&#39;2&#39;,&#39;&amp;sig2=zKqJ8Oy2YJxFy0iMzci7Vg&#39;,&#39;0CA0QFjAB&#39;)">PRB: Error When You Update or Delete New Rows in <EM>Access</EM> 97 Table</A></H3><SPAN style="display:inline-block"><BUTTON class="ws" title=""></BUTTON></SPAN><SPAN class="m">&nbsp;<SPAN dir="ltr">- 9:17</SPAN></SPAN><SPAN class="std nobr">&nbsp;- [ <A href="http://translate.google.co.th/translate?hl=th&sl=en&u=http://support.microsoft.com/kb/294842&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=translate&ct=result&resnum=2&ved=0CA8Q7gEwAQ&prev=/search%3Fq%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26hl%3Dth%26sa%3DG" class="fl">แปลหน้านี้</A> ]</SPAN><DIV class="s hc">Article <EM>ID</EM>: 294842 - <EM>Last</EM> Review: October 17, 2001 - Revision: 1.1 <B>...</B> Execute "<WBR>Create Table Table1(<EM>ID Identity</EM>(1,1) Constraint PrimaryKey Primary Key, <B>...</B> OLEDB.4.0;Data Source=" &amp; App.Path &amp; "\MyDatabase.<EM>mdb</EM>" strSQL = "<EM>select</EM> * from <B>...</B><BR><CITE>support.microsoft.com/kb/294842 - </CITE><SPAN class="gl"></SPAN></DIV><!--n--><!--m--></LI><DIV></DIV><LI class="g w0"><H3 class="r"><A href="http://www.access-programmers.co.uk/forums/showthread.php?t=63660" class="l" onmousedown="return clk(this.href,&#39;&#39;,&#39;&#39;,&#39;res&#39;,&#39;3&#39;,&#39;&amp;sig2=2wm1lONvQFEzP3zknrD9sQ&#39;,&#39;0CBMQFjAC&#39;)">Want to <EM>select last</EM> entry, having query probs - <EM>Access</EM> World Forums</A></H3><SPAN style="display:inline-block"><BUTTON class="ws" title=""></BUTTON></SPAN><SPAN class="m">&nbsp;<SPAN dir="ltr">- การเยี่ยมชม 2 ครั้ง</SPAN>&nbsp;<SPAN dir="ltr">- 9:17</SPAN></SPAN><SPAN class="std nobr">&nbsp;- [ <A href="http://translate.google.co.th/translate?hl=th&sl=en&u=http://www.access-programmers.co.uk/forums/showthread.php%3Ft%3D63660&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=translate&ct=result&resnum=3&ved=0CBkQ7gEwAg&prev=/search%3Fq%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26hl%3Dth%26sa%3DG" class="fl">แปลหน้านี้</A> ]</SPAN><DIV class="s"><DIV class="f">4 โพสต์&nbsp;-&nbsp;1 ผู้เขียน&nbsp;-&nbsp;โพสต์ครั้งล่าสุด:&nbsp;16 มี.ค. 2004</DIV>When I open the .<EM>mdb</EM> file it opesn as <EM>Access</EM> 2000 file format but when I <B>...</B> Syntax error. in query expression '<EM>ID</EM> = <EM>SELECT</EM> MAX(<EM>ID</EM>) FROM <B>...</B><BR><CITE><SPAN class="bc">www.access-programmers.co.uk › ... › <A href="http://www.google.co.th/url?q=http://www.access-programmers.co.uk/forums/forumdisplay.php%3Ff%3D8&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=breadcrumbs&resnum=3&ct=result&cd=1&ved=0CBUQ6QUoAQ&usg=AFQjCNECluiyDuaoVz9CFCRerRhFgISxWg">Queries</A></SPAN> - </CITE><SPAN class="gl"><A href="http://74.125.153.132/search?q=cache:Nu-QGOoYf5EJ:www.access-programmers.co.uk/forums/showthread.php%3Ft%3D63660+access+mdb+last+id+select+%40%40identity&cd=3&hl=th&ct=clnk&gl=th" onmousedown="return clk(&#39;http://74.125.153.132/search?q=cache:Nu-QGOoYf5EJ:www.access-programmers.co.uk/forums/showthread.php%3Ft%3D63660+access+mdb+last+id+select+%40%40identity&amp;cd=3&amp;hl=th&amp;ct=clnk&amp;gl=th&#39;,&#39;&#39;,&#39;&#39;,&#39;clnk&#39;,&#39;3&#39;,&#39;&amp;sig2=mzdSZ9zbO3TIBpNc3u0G-A&#39;)">แคช</A> - <A href="http://www.google.co.th/search?hl=th&q=related:www.access-programmers.co.uk/forums/showthread.php%3Ft%3D63660+access+mdb++last+id+select+%40%40identity&sa=X&ei=t1KYS7w6gY6RBa6PjIwB&ved=0CBcQHzAC">ใกล้เคียง</A></SPAN></DIV><!--n--><!--m--></LI><DIV></DIV><LI class="g w0"><H3 class="r"><A href="http://www.mikesdotnetting.com/Article/54/Getting-the-identity-of-the-most-recently-added-record" class="l" onmousedown="return clk(this.href,&#39;&#39;,&#39;&#39;,&#39;res&#39;,&#39;4&#39;,&#39;&amp;sig2=BtlwKKaHdS4NwQgXpScyow&#39;,&#39;0CB0QFjAD&#39;)">Getting the <EM>identity</EM> of the most recently added record</A></H3><SPAN style="display:inline-block"><BUTTON class="ws" title=""></BUTTON></SPAN><SPAN class="std nobr">&nbsp;- [ <A href="http://translate.google.co.th/translate?hl=th&sl=en&u=http://www.mikesdotnetting.com/Article/54/Getting-the-identity-of-the-most-recently-added-record&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=translate&ct=result&resnum=4&ved=0CB8Q7gEwAw&prev=/search%3Fq%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26hl%3Dth%26sa%3DG" class="fl">แปลหน้านี้</A> ]</SPAN><DIV class="s">int <EM>ID</EM>;. string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|<WBR>DataDirectory|Northwind.<EM>mdb</EM>"; <B>...</B> Dim query2 As String = "<EM>Select</EM> @@<EM>Identity</EM>". Dim <EM>ID</EM> As Integer <B>.....</B> I have tried to implement the <EM>last</EM> VB soln for an <EM>access</EM> db. <B>...</B><BR><CITE>www.mikesdotnetting.com/.../Getting-the-<B>identity</B>-of-the-most-recently-<WBR>added-record - </CITE><SPAN class="gl"><A href="http://74.125.153.132/search?q=cache:t86TsNJf6tsJ:www.mikesdotnetting.com/Article/54/Getting-the-identity-of-the-most-recently-added-record+access+mdb+last+id+select+%40%40identity&cd=4&hl=th&ct=clnk&gl=th" onmousedown="return clk(&#39;http://74.125.153.132/search?q=cache:t86TsNJf6tsJ:www.mikesdotnetting.com/Article/54/Getting-the-identity-of-the-most-recently-added-record+access+mdb+last+id+select+%40%40identity&amp;cd=4&amp;hl=th&amp;ct=clnk&amp;gl=th&#39;,&#39;&#39;,&#39;&#39;,&#39;clnk&#39;,&#39;4&#39;,&#39;&amp;sig2=U5cy-5bXpGe_Ln0inrl8FA&#39;)">แคช</A> - <A href="http://www.google.co.th/search?hl=th&q=related:www.mikesdotnetting.com/Article/54/Getting-the-identity-of-the-most-recently-added-record+access+mdb++last+id+select+%40%40identity&sa=X&ei=t1KYS7w6gY6RBa6PjIwB&ved=0CB4QHzAD">ใกล้เคียง</A></SPAN></DIV><!--n--><!--m--></LI><DIV></DIV><LI class="g w0"><H3 class="r"><A href="http://bytes.com/topic/asp-net/answers/632762-need-help-select-identity" class="l" onmousedown="return clk(this.href,&#39;&#39;,&#39;&#39;,&#39;res&#39;,&#39;5&#39;,&#39;&amp;sig2=BZQtqdguLpIei9E1UsGExA&#39;,&#39;0CCMQFjAE&#39;)">Need Help with <EM>Select</EM> @@ <EM>Identity</EM> - ASP.NET answers</A></H3><SPAN style="display:inline-block"><BUTTON class="ws" title=""></BUTTON></SPAN><SPAN class="std nobr">&nbsp;- [ <A href="http://translate.google.co.th/translate?hl=th&sl=en&u=http://bytes.com/topic/asp-net/answers/632762-need-help-select-identity&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=translate&ct=result&resnum=5&ved=0CC0Q7gEwBA&prev=/search%3Fq%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26hl%3Dth%26sa%3DG" class="fl">แปลหน้านี้</A> ]</SPAN><DIV class="s">15 Apr 2007 <B>...</B> to my <EM>access</EM> db. The data is submitted to the main table no problem, <B>.....</B> DataFile="~/App_Data/DATABASE.<EM>mdb</EM>" SelectCommand="<EM>SELECT</EM> [imgID] <B>....</B> @@<EM>IDENTITY</EM> returns the <EM>last ID</EM> generated for an <EM>identity</EM> column in any <B>...</B><BR><CITE><SPAN class="bc">bytes.com › <A href="http://www.google.co.th/url?q=http://bytes.com/topic/&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=breadcrumbs&resnum=5&ct=result&cd=1&ved=0CCgQ6QUoAA&usg=AFQjCNFKLJowzR9CHURbKRWlu_3r-6HVIw">topic</A> › <A href="http://www.google.co.th/url?q=http://bytes.com/topic/asp-net/&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=breadcrumbs&resnum=5&ct=result&cd=2&ved=0CCkQ6QUoAQ&usg=AFQjCNHM-ytBjDTK3MZRbI6hbt9qJKUBSQ">asp .net</A> › <A href="http://www.google.co.th/url?q=http://bytes.com/topic/asp-net/answers/&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=breadcrumbs&resnum=5&ct=result&cd=3&ved=0CCoQ6QUoAg&usg=AFQjCNE2-zD-qg4ekho7ADN9vpzRdaoLTw">answers</A></SPAN> - </CITE><SPAN class="gl"><A href="http://74.125.153.132/search?q=cache:vWm0c6Tzyo4J:bytes.com/topic/asp-net/answers/632762-need-help-select-identity+access+mdb+last+id+select+%40%40identity&cd=5&hl=th&ct=clnk&gl=th" onmousedown="return clk(&#39;http://74.125.153.132/search?q=cache:vWm0c6Tzyo4J:bytes.com/topic/asp-net/answers/632762-need-help-select-identity+access+mdb+last+id+select+%40%40identity&amp;cd=5&amp;hl=th&amp;ct=clnk&amp;gl=th&#39;,&#39;&#39;,&#39;&#39;,&#39;clnk&#39;,&#39;5&#39;,&#39;&amp;sig2=rj0Wh75OU6mjCQALZxP-og&#39;)">แคช</A> - <A href="http://www.google.co.th/search?hl=th&q=related:bytes.com/topic/asp-net/answers/632762-need-help-select-identity+access+mdb++last+id+select+%40%40identity&sa=X&ei=t1KYS7w6gY6RBa6PjIwB&ved=0CCwQHzAE">ใกล้เคียง</A></SPAN><DIV class="fc"><A href="http://www.google.co.th/url?q=http://bytes.com/topic/asp-classic/answers/52672-connection-code-i-think&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=forum_cluster&resnum=5&ct=result&cd=1&ved=0CCQQrAIoADAE&usg=AFQjCNG-tddqZGnxMzrBOxrd-VPfFK9ueQ">connection code, I think. - ASP / Active Server Pages answers</A>‎ - <SPAN class="f">8 ส.ค. 2009</SPAN><BR><A href="http://www.google.co.th/url?q=http://bytes.com/topic/asp-classic/answers/52645-access-insert-statement&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=forum_cluster&resnum=5&ct=result&cd=2&ved=0CCUQrAIoATAE&usg=AFQjCNGVxdDZpIfJr6Ro3wvFv_rjWNnbYQ"><EM>access</EM> insert statement - ASP / Active Server Pages answers</A>‎ - <SPAN class="f">5 ส.ค. 2009</SPAN><BR><P style="margin:.3em 0"><A class="fl" href="http://www.google.co.th/search?hl=th&q=+site:bytes.com+access+mdb++last+id+select+%40%40identity&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=forum_cluster&resnum=5&ct=more-results&ved=0CCYQrQIwBA">ผลการค้นหาเพิ่มเติมจาก bytes.com&nbsp;»</A></P></DIV></DIV><!--n--><!--m--></LI><DIV></DIV><LI class="g w0"><H3 class="r"><A href="http://forums.aspfree.com/net-development-11/select-identity-example-119693.html" class="l" onmousedown="return clk(this.href,&#39;&#39;,&#39;&#39;,&#39;res&#39;,&#39;6&#39;,&#39;&amp;sig2=T5-f_bkHWfml0Et1AuJzcA&#39;,&#39;0CDEQFjAF&#39;)"><EM>Select</EM> @@<EM>identity</EM> Example - ASP Free</A></H3><SPAN style="display:inline-block"><BUTTON class="ws" title=""></BUTTON></SPAN><SPAN class="std nobr">&nbsp;- [ <A href="http://translate.google.co.th/translate?hl=th&sl=en&u=http://forums.aspfree.com/net-development-11/select-identity-example-119693.html&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=translate&ct=result&resnum=6&ved=0CDcQ7gEwBQ&prev=/search%3Fq%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26hl%3Dth%26sa%3DG" class="fl">แปลหน้านี้</A> ]</SPAN><DIV class="s"><DIV class="f">12 โพสต์&nbsp;-&nbsp;2 ผู้เขียน&nbsp;-&nbsp;โพสต์ครั้งล่าสุด:&nbsp;22 มิ.ย. 2006</DIV>Before i go ahead and try, does this method work with <EM>access</EM>? <B>....</B> MapPath("stw.<WBR><EM>mdb</EM>")&amp;"") objCmd = New OleDbCommand("Insert into customerTbl <B>...</B> Text &amp;"'); <EM>select</EM> @@<EM>IDENTITY</EM>", objConn) dim <EM>LastID</EM> as integer objConn. <B>...</B><BR><CITE><SPAN class="bc">forums.aspfree.com › <A href="http://www.google.co.th/url?q=http://forums.aspfree.com/programming-3/&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=breadcrumbs&resnum=6&ct=result&cd=1&ved=0CDMQ6QUoAA&usg=AFQjCNFarVyV3gQO9il-EWphm_10fkAseQ">Programming</A> › <A href="http://www.google.co.th/url?q=http://forums.aspfree.com/net-development-11/&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=breadcrumbs&resnum=6&ct=result&cd=2&ved=0CDQQ6QUoAQ&usg=AFQjCNFPBZ0N4vHCurI1cMS2icZ7m6bxnQ">.NET Development</A></SPAN> - </CITE><SPAN class="gl"><A href="http://74.125.153.132/search?q=cache:-CbLF1dA35EJ:forums.aspfree.com/net-development-11/select-identity-example-119693.html+access+mdb+last+id+select+%40%40identity&cd=6&hl=th&ct=clnk&gl=th" onmousedown="return clk(&#39;http://74.125.153.132/search?q=cache:-CbLF1dA35EJ:forums.aspfree.com/net-development-11/select-identity-example-119693.html+access+mdb+last+id+select+%40%40identity&amp;cd=6&amp;hl=th&amp;ct=clnk&amp;gl=th&#39;,&#39;&#39;,&#39;&#39;,&#39;clnk&#39;,&#39;6&#39;,&#39;&amp;sig2=RtY_yHxtHrooJZ9W6Y4DhA&#39;)">แคช</A> - <A href="http://www.google.co.th/search?hl=th&q=related:forums.aspfree.com/net-development-11/select-identity-example-119693.html+access+mdb++last+id+select+%40%40identity&sa=X&ei=t1KYS7w6gY6RBa6PjIwB&ved=0CDYQHzAF">ใกล้เคียง</A></SPAN></DIV><!--n--><!--m--></LI><DIV></DIV><LI class="g w0"><H3 class="r"><A href="http://forums.asp.net/p/1515374/3624003.aspx" class="l" onmousedown="return clk(this.href,&#39;&#39;,&#39;&#39;,&#39;res&#39;,&#39;7&#39;,&#39;&amp;sig2=PcMX_PrEakN8w9SPyY9Orw&#39;,&#39;0CDsQFjAG&#39;)">MS <EM>Access</EM> &amp; <EM>Select</EM> @@<EM>Identity</EM> - ASP.NET Forums</A></H3><SPAN style="display:inline-block"><BUTTON class="ws" title=""></BUTTON></SPAN><SPAN class="std nobr">&nbsp;- [ <A href="http://translate.google.co.th/translate?hl=th&sl=en&u=http://forums.asp.net/p/1515374/3624003.aspx&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=translate&ct=result&resnum=7&ved=0CD0Q7gEwBg&prev=/search%3Fq%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26hl%3Dth%26sa%3DG" class="fl">แปลหน้านี้</A> ]</SPAN><DIV class="s"><DIV class="f">7 โพสต์&nbsp;-&nbsp;4 ผู้เขียน&nbsp;-&nbsp;โพสต์ครั้งล่าสุด:&nbsp;19 ม.ค.</DIV>MS <EM>Access</EM> &amp; <EM>Select</EM> @@<EM>Identity</EM>. <EM>Last</EM> post 01-19-2010 3:40 AM by j-will. <B>...</B> Dim query2 As String = "<EM>Select</EM> @@<EM>Identity</EM>" Dim <EM>ID</EM> As Integer Dim connect As <B>...</B> OLEDB.4.0;Data Source=|DataDirectory|Nwind.<EM>mdb</EM>" Using conn As New <B>...</B><BR><CITE>forums.asp.net/p/1515374/3624003.aspx - </CITE><SPAN class="gl"><A href="http://74.125.153.132/search?q=cache:MxqSBGahdg4J:forums.asp.net/p/1515374/3624003.aspx+access+mdb+last+id+select+%40%40identity&cd=7&hl=th&ct=clnk&gl=th" onmousedown="return clk(&#39;http://74.125.153.132/search?q=cache:MxqSBGahdg4J:forums.asp.net/p/1515374/3624003.aspx+access+mdb+last+id+select+%40%40identity&amp;cd=7&amp;hl=th&amp;ct=clnk&amp;gl=th&#39;,&#39;&#39;,&#39;&#39;,&#39;clnk&#39;,&#39;7&#39;,&#39;&amp;sig2=-MIJ_dbvJZyqnwkWbgp6YA&#39;)">แคช</A></SPAN></DIV><!--n--><!--m--></LI><DIV></DIV><LI class="g w0"><H3 class="r"><A href="http://www.eggheadcafe.com/software/aspnet/29729063/need-help-with-select-.aspx" class="l" onmousedown="return clk(this.href,&#39;&#39;,&#39;&#39;,&#39;res&#39;,&#39;8&#39;,&#39;&amp;sig2=yakBluhSYFXsLb1yEsN_Hw&#39;,&#39;0CEEQFjAH&#39;)">Need Help with <EM>Select</EM> @@ <EM>Identity</EM> in ASP.NET</A></H3><SPAN style="display:inline-block"><BUTTON class="ws" title=""></BUTTON></SPAN><SPAN class="std nobr">&nbsp;- [ <A href="http://translate.google.co.th/translate?hl=th&sl=en&u=http://www.eggheadcafe.com/software/aspnet/29729063/need-help-with-select-.aspx&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=translate&ct=result&resnum=8&ved=0CEIQ7gEwBw&prev=/search%3Fq%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26hl%3Dth%26sa%3DG" class="fl">แปลหน้านี้</A> ]</SPAN><DIV class="s">14 Apr 2007 <B>...</B> DataFile="~/App_Data/DATABASE.<EM>mdb</EM>" SelectCommand="<EM>SELECT</EM> [imgID], <B>....</B> <EM>SCOPE_IDENTITY</EM> returns the <EM>last ID</EM> generated in the caller scope. <B>...</B><BR><CITE>www.eggheadcafe.com/software/aspnet/.../need-help-with-<B>select</B>-.aspx - </CITE><SPAN class="gl"><A href="http://74.125.153.132/search?q=cache:AbXaiCQ1CqwJ:www.eggheadcafe.com/software/aspnet/29729063/need-help-with-select-.aspx+access+mdb+last+id+select+%40%40identity&cd=8&hl=th&ct=clnk&gl=th" onmousedown="return clk(&#39;http://74.125.153.132/search?q=cache:AbXaiCQ1CqwJ:www.eggheadcafe.com/software/aspnet/29729063/need-help-with-select-.aspx+access+mdb+last+id+select+%40%40identity&amp;cd=8&amp;hl=th&amp;ct=clnk&amp;gl=th&#39;,&#39;&#39;,&#39;&#39;,&#39;clnk&#39;,&#39;8&#39;,&#39;&amp;sig2=fFYia2Ydh2t-q_Eqv4zJnQ&#39;)">แคช</A></SPAN></DIV><!--n--><!--m--></LI><DIV></DIV><LI class="g w0"><H3 class="r"><A href="http://72.5.124.102/thread.jspa?threadID=564069&messageID=2867549" class="l" onmousedown="return clk(this.href,&#39;&#39;,&#39;&#39;,&#39;res&#39;,&#39;9&#39;,&#39;&amp;sig2=b8bc7mGMnMiWpPwB6_pOPA&#39;,&#39;0CEYQFjAI&#39;)">Java Database Connectivity (JDBC) - capturing an <EM>id</EM> from the <EM>last</EM> <B>...</B></A></H3><SPAN style="display:inline-block"><BUTTON class="ws" title=""></BUTTON></SPAN><SPAN class="std nobr">&nbsp;- [ <A href="http://translate.google.co.th/translate?hl=th&sl=en&u=http://72.5.124.102/thread.jspa%3FthreadID%3D564069%26messageID%3D2867549&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=translate&ct=result&resnum=9&ved=0CEcQ7gEwCA&prev=/search%3Fq%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26hl%3Dth%26sa%3DG" class="fl">แปลหน้านี้</A> ]</SPAN><DIV class="s"><EM>SELECT</EM> @@<EM>IDENTITY</EM> You can get the <EM>id</EM>. This doesn't work well in threaded apps <B>...</B> "jdbc:odbc:DRIVER={Microsoft <EM>Access</EM> Driver (*.<EM>mdb</EM>)};DBQ=Person.<EM>mdb</EM>"; <B>...</B><BR><CITE>72.5.124.102/thread.jspa?threadID=564069&amp;messageID=2867549 - </CITE><SPAN class="gl"><A href="http://74.125.153.132/search?q=cache:GbdN2UwVs90J:72.5.124.102/thread.jspa%3FthreadID%3D564069%26messageID%3D2867549+access+mdb+last+id+select+%40%40identity&cd=9&hl=th&ct=clnk&gl=th" onmousedown="return clk(&#39;http://74.125.153.132/search?q=cache:GbdN2UwVs90J:72.5.124.102/thread.jspa%3FthreadID%3D564069%26messageID%3D2867549+access+mdb+last+id+select+%40%40identity&amp;cd=9&amp;hl=th&amp;ct=clnk&amp;gl=th&#39;,&#39;&#39;,&#39;&#39;,&#39;clnk&#39;,&#39;9&#39;,&#39;&amp;sig2=B-34zcWAvfKxkUkeJCbpGA&#39;)">แคช</A></SPAN></DIV><!--n--><!--m--></LI><DIV></DIV><LI class="g w0"><H3 class="r"><A href="http://www.bigresource.com/ASP-Get-last-insert-autonumber-from-Access-F6ztrs2x.html" class="l" onmousedown="return clk(this.href,&#39;&#39;,&#39;&#39;,&#39;res&#39;,&#39;10&#39;,&#39;&amp;sig2=aicBQJ52ZHxs5WbwQnRRTg&#39;,&#39;0CEsQFjAJ&#39;)">ASP :: Get <EM>Last</EM> Insert Autonumber From <EM>Access</EM></A></H3><SPAN style="display:inline-block"><BUTTON class="ws" title=""></BUTTON></SPAN><SPAN class="m">&nbsp;<SPAN dir="ltr">- 9:07</SPAN></SPAN><SPAN class="std nobr">&nbsp;- [ <A href="http://translate.google.co.th/translate?hl=th&sl=en&u=http://www.bigresource.com/ASP-Get-last-insert-autonumber-from-Access-F6ztrs2x.html&ei=t1KYS7w6gY6RBa6PjIwB&sa=X&oi=translate&ct=result&resnum=10&ved=0CE4Q7gEwCQ&prev=/search%3Fq%3Daccess%2Bmdb%2B%2Blast%2Bid%2Bselect%2B%2540%2540identity%26hl%3Dth%26sa%3DG" class="fl">แปลหน้านี้</A> ]</SPAN><DIV class="s">I tried adding it after the close paren, after the <EM>select</EM> @@<EM>identity</EM>, and after both <B>.....</B> ASP + <EM>Access</EM> Question (Determining The <EM>Last Id</EM> Generated By <EM>Access</EM>) <B>...</B> I was wondering if this is possible for that... or is <EM>mdb</EM> file restricted <B>...</B><BR><CITE>www.bigresource.com/ASP-Get-<B>last</B>-insert-autonumber-from-<B>Access</B>-<WBR>F6ztrs2x.html - </CITE><SPAN class="gl"><A href="http://74.125.153.132/search?q=cache:CJTDhE-TFU8J:www.bigresource.com/ASP-Get-last-insert-autonumber-from-Access-F6ztrs2x.html+access+mdb+last+id+select+%40%40identity&cd=10&hl=th&ct=clnk&gl=th" onmousedown="return clk(&#39;http://74.125.153.132/search?q=cache:CJTDhE-TFU8J:www.bigresource.com/ASP-Get-last-insert-autonumber-from-Access-F6ztrs2x.html+access+mdb+last+id+select+%40%40identity&amp;cd=10&amp;hl=th&amp;ct=clnk&amp;gl=th&#39;,&#39;&#39;,&#39;&#39;,&#39;clnk&#39;,&#39;10&#39;,&#39;&amp;sig2=7IuoRIrGuJ-DdVW7m9kOPQ&#39;)">แคช</A> - <A href="http://www.google.co.th/search?hl=th&q=related:www.bigresource.com/ASP-Get-last-insert-autonumber-from-Access-F6ztrs2x.html+access+mdb++last+id+select+%40%40identity&sa=X&ei=t1KYS7w6gY6RBa6PjIwB&ved=0CEwQHzAJ">ใกล้เคียง</A></SPAN></DIV><!--n--></LI><DIV></DIV></OL></DIV><!--z--><DIV id="wrz" class="e" style="display:none">คุณได้ลบผลการค้นหาออกจากการค้นหานี้แล้ว <SPAN><BUTTON class="wpb" title="-" style="background-position: -105px -74px; "></BUTTON><SPAN class="link std">ซ่อนผลการค้นหาที่ถูกลบ</SPAN></SPAN></DIV><DIV id="wrm" class="std" style="display:none">กำลังโหลด...</DIV><OL id="wrg" style="display:block;margin-left:3em"></OL></DIV><BR clear="all"><DIV id="navcnt"><TABLE id="nav" align="center" style="border-collapse:collapse;margin:auto;text-align:center;direction:ltr;margin-bottom:1.4em"><TBODY><TR valign="top"><TD class="b"><SPAN class="csb" style="background-position:-26px 0;width:18px"></SPAN></TD><TD class="cur"><SPAN class="csb" style="background-position:-44px 0;width:16px"></SPAN>1</TD><TD><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&start=10&sa=N"><SPAN class="csb ch" style="background-position:-60px 0;width:16px"></SPAN>2</A></TD><TD><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&start=20&sa=N"><SPAN class="csb ch" style="background-position:-60px 0;width:16px"></SPAN>3</A></TD><TD><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&start=30&sa=N"><SPAN class="csb ch" style="background-position:-60px 0;width:16px"></SPAN>4</A></TD><TD><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&start=40&sa=N"><SPAN class="csb ch" style="background-position:-60px 0;width:16px"></SPAN>5</A></TD><TD><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&start=50&sa=N"><SPAN class="csb ch" style="background-position:-60px 0;width:16px"></SPAN>6</A></TD><TD><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&start=60&sa=N"><SPAN class="csb ch" style="background-position:-60px 0;width:16px"></SPAN>7</A></TD><TD><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&start=70&sa=N"><SPAN class="csb ch" style="background-position:-60px 0;width:16px"></SPAN>8</A></TD><TD><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&start=80&sa=N"><SPAN class="csb ch" style="background-position:-60px 0;width:16px"></SPAN>9</A></TD><TD><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&start=90&sa=N"><SPAN class="csb ch" style="background-position:-60px 0;width:16px"></SPAN>10</A></TD><TD class="b"><A href="http://www.google.co.th/search?hl=th&q=access+mdb++last+id+select+%40%40identity&start=10&sa=N"><SPAN class="csb ch" style="background-position:-76px 0;margin-right:34px;width:66px"></SPAN>ถัดไป</A></TD></TR></TBODY></TABLE></DIV><DIV style="height:1px;line-height:0"></DIV><DIV style="text-align:center;margin-top:1.4em" class="clr"><DIV id="bsf" style="padding:1.8em 0;margin-top:0"><FORM method="get" action="http://www.google.co.th/search"><DIV><INPUT class="lst" type="text" name="q" size="42" maxlength="2048" value="access mdb  last id select @@identity" title="ค้นหา"> <INPUT type="submit" name="btnG" class="lsb" style="margin:0 2px 0 5px" value="ค้นหา"><INPUT type="hidden" name="hl" value="th"><INPUT type="hidden" name="sa" value="2"></DIV></FORM><P style="margin:1.2em 0 0"><A href="http://www.google.co.th/swr?q=access+mdb++last+id+select+%40%40identity&hl=th&swrnum=9000">ค้นหาภายในผลการค้นหา</A> - <A href="http://www.google.co.th/language_tools?q=access+mdb++last+id+select+%40%40identity&hl=th">เครื่องมือภาษา</A> - <A href="http://www.google.co.th/intl/th/help.html">เคล็ดลับการค้นหา</A> - <A href="http://www.google.co.th/quality_form?q=access+mdb++last+id+select+%40%40identity&hl=th" target="_blank">ช่วยเราปรับปรุงให้ถูกใจคุณ</A></P></DIV><P id="flp"><A href="http://www.google.co.th/">หน้าแรก&nbsp;Google</A> - <A href="http://www.google.co.th/intl/th/ads/index.html">โปรแกรมโฆษณา</A> - <A href="http://www.google.co.th/services/">ทางออกทางธุรกิจ</A> - <A href="http://www.google.co.th/intl/th/privacy.html">ข้อมูลส่วนบุคคล</A> - <A href="http://www.google.co.th/intl/th/about.html">เกี่ยวกับ Google ทั้งหมด</A></P></DIV><TEXTAREA style="display:none" id="hcache"></TEXTAREA><DIV id="xjsd"><SCRIPT src="./access mdb last id select @@identity - ค้นหาด้วย Google_files/K6wfyjb0st4.js"></SCRIPT></DIV><DIV id="xjsi"><SCRIPT>if(google.y)google.y.first=[];if(google.y)google.y.first=[];google.dstr=[];google.rein=[];window.setTimeout(function(){var a=document.createElement("script");a.src="/extern_js/f/CgJ0aBICdGgrMAo4XEAdLCswDjgMLCswFjgXLCswFzgGLCswGDgFLCswGTgZLCswITgvQAEsKzAlOMqIASwrMCY4CSwrMCc4BCwrMDw4AiwrMEQ4AiwrMEU4ASw/K6wfyjb0st4.js";(document.getElementById("xjsd")||document.body).appendChild(a);if(google.timers&&google.timers.load.t)google.timers.load.t.xjsls=(new Date).getTime();},0);
;window.mbtb1={tbs:"",docid:"15552066865647043082",usg:"1195",obd:false};google.base_href='/search?q\x3daccess+mdb++last+id+select+%40%40identity\x26hl\x3dth\x26sa\x3dG';google.y.first.push(function(){google.Toolbelt.resetListeners();;google.sw({q:'access mdb  last id select @@identity',nn:'ผู้ค้นหา'});google.ac.b=true;google.ac.i(document.gs,document.gs.q,'','access mdb  last id select @@identity','',{});google.riu={render:function(){window.setTimeout(function(){var a=document.createElement("script");a.src="/extern_js/f/CgJ0aBICdGgrMD84Aiw/7vfpKoJ1wlw.js";(document.getElementById("xjsd")||document.body).appendChild(a);},0);
}};;google.History&&google.History.initialize('/search?hl\x3dth\x26amp;q\x3daccess+mdb++last+id+select+%40%40identity\x26amp;btnG\x3d%E0%B8%84%E0%B9%89%E0%B8%99%E0%B8%AB%E0%B8%B2\x26amp;meta\x3d\x26amp;aq\x3df\x26amp;oq\x3d')});if(google.j&&google.j.en&&google.j.xi){window.setTimeout(google.j.xi,0);google.fade=null;}</SCRIPT></DIV><SCRIPT>(function(){
var b,d,e,f;function g(a,c){if(a.removeEventListener){a.removeEventListener("load",c,false);a.removeEventListener("error",c,false)}else{a.detachEvent("onload",c);a.detachEvent("onerror",c)}}function h(a){f=(new Date).getTime();++d;a=a||window.event;var c=a.target||a.srcElement;g(c,h)}var i=document.getElementsByTagName("img");b=i.length;d=0;for(var j=0,k;j<b;++j){k=i[j];g(k,h);if(k.complete||typeof k.src!="string"||!k.src)++d;else if(k.addEventListener){k.addEventListener("load",h,false);k.addEventListener("error",
h,false)}else{k.attachEvent("onload",h);k.attachEvent("onerror",h)}}e=b-d;function l(){google.timers.load.t.ol=(new Date).getTime();google.timers.load.t.iml=f;google.kCSI.imc=d;google.kCSI.imn=b;google.kCSI.imp=e;google.report&&google.report(google.timers.load,google.kCSI)}if(window.addEventListener)window.addEventListener("load",l,false);else if(window.attachEvent)window.attachEvent("onload",l);google.timers.load.t.prt=(f=(new Date).getTime());
})();
</SCRIPT></DIV>  <SCRIPT src="./access mdb last id select @@identity - ค้นหาด้วย Google_files/search"></SCRIPT></BODY></HTML>